-
Re: SUM COLLECT Multiple referenced columns
@Michelle Maas Let me share a solution I built that did something similar. This may help you automate your solution. I built a system for tracking Bills of Lading in our warehouse, and the supervisor…1 · -
Re: Create a sheet that lists all working days in the date column
@Album This formula will cut out Saturdays and Sundays. Start by setting your first date in Row 1 manually, then below it enter: =IF(WEEKDAY(Date1) = 6, Date1 + 3, IF(WEEKDAY(Date1) = 7, Date1 + 2, D…1 · -
Re: Is there a way to trigger a workflow following an automated update second request?
@Sherry Hamilton You should be able to do this with just an automation workflow. Create a new workflow: Trigger: When a date is reached (in your new helper date column.) Select time of day to run. Co…1 · -
Re: #NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
@MPath Sorry for the delay in response. I'm not working with Smartsheet any longer due to a layoff so I'm rarely on here now. I see a few issues. I am assuming that the reference {Artikel-ArtikelLeve…1 · -
Re: Check Parent box if Child box is checked
Try this in your checkbox column on the parent row: =IF(COUNTIF(CHILDREN(Checkbox@row), 1) >0, 1, 0) (where "Checkbox" is the column name for the checkbox column) English: If the count o…2 ·